#coding=utf-8
'''
Created on 2017年10月16日

@author: hadoop
'''
import pymysql;
conn  = pymysql.connect(host="192.168.50.116",port=3306,user="admin",passwd="tcxy@#$dev",db="tcxy_cloud",charset="utf8");
cursor = conn .cursor();
sql = "select id,name,cellphone from user where login_id='zhuyi123'";
cursor.execute(sql);
results = cursor.fetchall();
for row in results:
    print ("id:"+row[0]+",name:"+row[1]+",cellphone:"+row[2]);
conn.close();

